Data type considerations and exceptions
When replicating from one AWS Aurora Cloud for PostgreSQL database to a PostgreSQL-based target (e.g. Microsoft Azure Database for PostgreSQL), source and target data types are identical, with the following exceptions:
AWS Aurora Cloud for PostgreSQL source | PostgreSQL-based target |
---|---|
ENUM |
STRING |
COMPOSITE |
STRING |
NUMERIC |
NUMERIC (28,6) |
NUMERIC (p,s) A numeric array with precision and scale. |
NUMERIC A numeric array without precision and scale. |
TINTERVAL |
Information note
As PostgreSQL have discontinued support for the TINTERVAL data type, tables with this data type will not be created on the target if the target database version does not support it. |